SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 66540: SAS® Management Console and SAS® Data Integration Studio might return the message "table failed to update" when you use the Update Metadata tool

DetailsHotfixAboutRate It

The Update Metadata tool in SAS® Management Console 9.4_M6 or in SAS® Data Integration Studio 4.904 returns an incorrect error message similar to the following when table metadata already matches the data source:

0 of 1 tables updated.  1 table failed to update.

If you click Yes to view details after the step runs, you see the SAS log for the METALIB procedure. The log provides the following clarification that the table metadata matched the data source, and therefore no update was required:

NOTE: Metadata for 0 tables was updated.
NOTE: Metadata for 1 tables matched the data sources.

Click the Hot Fix tab in this note to access the hot fix for this issue.



Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Management ConsoleMicrosoft® Windows® for x649.4_M69.4_M89.4 TS1M69.4 TS1M8
Microsoft Windows 8 Enterprise 32-bit9.4_M69.4_M89.4 TS1M69.4 TS1M8
Microsoft Windows 8 Enterprise x649.4_M69.4_M89.4 TS1M69.4 TS1M8
Microsoft Windows 8 Pro 32-bit9.4_M69.4_M89.4 TS1M69.4 TS1M8
Microsoft Windows 8 Pro x649.4_M69.4_M89.4 TS1M69.4 TS1M8
Microsoft Windows 8.1 Enterprise 32-bit9.4_M69.4_M89.4 TS1M69.4 TS1M8
Microsoft Windows 8.1 Enterprise x649.4_M69.4_M89.4 TS1M69.4 TS1M8
Microsoft Windows 8.1 Pro 32-bit9.4_M69.4_M89.4 TS1M69.4 TS1M8
Microsoft Windows 8.1 Pro x649.4_M69.4_M89.4 TS1M69.4 TS1M8
Microsoft Windows 109.4_M69.4_M89.4 TS1M69.4 TS1M8
Microsoft Windows Server 2012 Datacenter9.4_M69.4_M89.4 TS1M69.4 TS1M8
Microsoft Windows Server 2012 R2 Datacenter9.4_M69.4_M89.4 TS1M69.4 TS1M8
Microsoft Windows Server 2012 R2 Std9.4_M69.4_M89.4 TS1M69.4 TS1M8
Microsoft Windows Server 2012 Std9.4_M69.4_M89.4 TS1M69.4 TS1M8
Microsoft Windows Server 20169.4_M69.4_M89.4 TS1M69.4 TS1M8
Microsoft Windows Server 20199.4_M69.4_M89.4 TS1M69.4 TS1M8
Windows 7 Enterprise 32 bit9.4_M69.4_M89.4 TS1M69.4 TS1M8
Windows 7 Enterprise x649.4_M69.4_M89.4 TS1M69.4 TS1M8
Windows 7 Home Premium 32 bit9.4_M69.4_M89.4 TS1M69.4 TS1M8
Windows 7 Home Premium x649.4_M69.4_M89.4 TS1M69.4 TS1M8
Windows 7 Professional 32 bit9.4_M69.4_M89.4 TS1M69.4 TS1M8
Windows 7 Professional x649.4_M69.4_M89.4 TS1M69.4 TS1M8
Windows 7 Ultimate 32 bit9.4_M69.4_M89.4 TS1M69.4 TS1M8
Windows 7 Ultimate x649.4_M69.4_M89.4 TS1M69.4 TS1M8
64-bit Enabled AIX9.4_M69.4_M89.4 TS1M69.4 TS1M8
64-bit Enabled Solaris9.4_M69.4_M89.4 TS1M69.4 TS1M8
HP-UX IPF9.4_M69.4_M89.4 TS1M69.4 TS1M8
Linux for x649.4_M69.4_M89.4 TS1M69.4 TS1M8
Solaris for x649.4_M69.4_M89.4 TS1M69.4 TS1M8
SAS SystemSAS Data Integration StudioMicrosoft® Windows® for x644.9049.4 TS1M6
Microsoft Windows 8 Enterprise 32-bit4.9049.4 TS1M6
Microsoft Windows 8 Enterprise x644.9049.4 TS1M6
Microsoft Windows 8 Pro 32-bit4.9049.4 TS1M6
Microsoft Windows 8 Pro x644.9049.4 TS1M6
Microsoft Windows 8.1 Enterprise 32-bit4.9049.4 TS1M6
Microsoft Windows 8.1 Enterprise x644.9049.4 TS1M6
Microsoft Windows 8.1 Pro 32-bit4.9049.4 TS1M6
Microsoft Windows 8.1 Pro x644.9049.4 TS1M6
Microsoft Windows 104.9049.4 TS1M6
Microsoft Windows Server 2012 Datacenter4.9049.4 TS1M6
Microsoft Windows Server 2012 R2 Datacenter4.9049.4 TS1M6
Microsoft Windows Server 2012 R2 Std4.9049.4 TS1M6
Microsoft Windows Server 2012 Std4.9049.4 TS1M6
Microsoft Windows Server 20164.9049.4 TS1M6
Microsoft Windows Server 20194.9049.4 TS1M6
Windows 7 Enterprise 32 bit4.9049.4 TS1M6
Windows 7 Enterprise x644.9049.4 TS1M6
Windows 7 Home Premium 32 bit4.9049.4 TS1M6
Windows 7 Home Premium x644.9049.4 TS1M6
Windows 7 Professional 32 bit4.9049.4 TS1M6
Windows 7 Professional x644.9049.4 TS1M6
Windows 7 Ultimate 32 bit4.9049.4 TS1M6
Windows 7 Ultimate x644.9049.4 TS1M6
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.